2024-11-04 23:26:36,784 [ 680113 ] INFO : ClickHouse root is not set. Will use /home/ubuntu/_work/ClickHouse/ClickHouse (runner:42, check_args_and_update_paths) 2024-11-04 23:26:36,785 [ 680113 ] INFO : Cases dir is not set. Will use /home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration (runner:86, check_args_and_update_paths) 2024-11-04 23:26:36,785 [ 680113 ] INFO : utils dir is not set. Will use /home/ubuntu/_work/ClickHouse/ClickHouse/utils (runner:97, check_args_and_update_paths) 2024-11-04 23:26:36,785 [ 680113 ] INFO : base_configs_dir: /home/ubuntu/_work/ClickHouse/ClickHouse/programs/server, binary: /home/ubuntu/_work/_temp/test/build/clickhouse, cases_dir: /home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration (runner:99, check_args_and_update_paths) clickhouse_integration_tests_volume Running pytest container as: 'docker run --rm --name clickhouse_integration_tests_ep2t5a --privileged --dns-search='.' --volume=/home/ubuntu/_work/_temp/test/build/clickhouse-odbc-bridge:/clickhouse-odbc-bridge --volume=/home/ubuntu/_work/_temp/test/build/clickhouse:/clickhouse --volume=/home/ubuntu/_work/_temp/test/build/clickhouse-library-bridge:/clickhouse-library-bridge --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/programs/server:/clickhouse-config --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration:/ClickHouse/tests/integration --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/backupview:/ClickHouse/utils/backupview --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/grpc-client/pb2:/ClickHouse/utils/grpc-client/pb2 --volume=/run:/run/host:ro --volume=clickhouse_integration_tests_volume:/var/lib/docker -e DOCKER_DOTNET_CLIENT_TAG=11de0b29a15d -e DOCKER_HELPER_TAG=2cffe1eae894 -e DOCKER_BASE_TAG=1d1c87eee2db -e DOCKER_KERBERIZED_HADOOP_TAG=ce74919e88f5 -e DOCKER_KERBEROS_KDC_TAG=9391ecdee8d7 -e DOCKER_MYSQL_GOLANG_CLIENT_TAG=9bec2a638e6e -e DOCKER_MYSQL_JAVA_CLIENT_TAG=766bff31cfe4 -e DOCKER_MYSQL_JS_CLIENT_TAG=41ba7c2ec2a1 -e DOCKER_MYSQL_PHP_CLIENT_TAG=88be89c1e3b6 -e DOCKER_NGINX_DAV_TAG=b55ac9cd7519 -e DOCKER_POSTGRESQL_JAVA_CLIENT_TAG=a4eff5c7f4d6 -e DOCKER_PYTHON_BOTTLE_TAG=a2d3dc777d0c -e DOCKER_CLIENT_TIMEOUT=300 -e COMPOSE_HTTP_TIMEOUT=600 -e PYTHONUNBUFFERED=1 -e PYTEST_ADDOPTS="--dist=loadfile -n 10 -rfEps --run-id=0 --color=no --durations=0 test_storage_rabbitmq/test.py::test_rabbitmq_random_detach test_storage_rabbitmq/test.py::test_rabbitmq_reject_broken_messages test_storage_rabbitmq/test.py::test_rabbitmq_restore_failed_connection_without_losses_1 test_storage_rabbitmq/test.py::test_rabbitmq_restore_failed_connection_without_losses_2 'test_storage_rabbitmq/test.py::test_rabbitmq_select[0]' 'test_storage_rabbitmq/test.py::test_rabbitmq_select[1]' test_storage_rabbitmq/test.py::test_rabbitmq_select_empty test_storage_rabbitmq/test.py::test_rabbitmq_sharding_between_queues_publish test_storage_rabbitmq/test.py::test_rabbitmq_topic_exchange test_storage_rabbitmq/test.py::test_rabbitmq_tsv_with_delimiter test_storage_rabbitmq/test.py::test_rabbitmq_vhost test_storage_rabbitmq/test.py::test_rabbitmq_virtual_columns test_storage_rabbitmq/test.py::test_rabbitmq_virtual_columns_with_materialized_view test_storage_rabbitmq/test.py::test_row_based_formats test_storage_url_http_headers/test.py::test_storage_url_http_headers test_storage_url_http_headers/test.py::test_storage_url_redirected_headers test_system_logs/test_system_logs.py::test_system_logs_engine_expr test_system_logs/test_system_logs.py::test_system_logs_order_by_expr test_system_logs/test_system_logs.py::test_system_logs_settings_expr 'test_system_merges/test.py::test_merge_simple[]' 'test_system_merges/test.py::test_merge_simple[replicated]' 'test_system_merges/test.py::test_mutation_simple[]' 'test_system_merges/test.py::test_mutation_simple[replicated]' test_system_queries/test.py::test_DROP_DNS_CACHE test_system_queries/test.py::test_RELOAD_CONFIG_AND_MACROS test_system_queries/test.py::test_SYSTEM_RELOAD_DICTIONARY test_system_queries/test.py::test_system_flush_logs test_temporary_data_in_cache/test.py::test_cache_evicted_by_temporary_data test_truncate_database/test_replicated.py::test_truncate_database_replicated test_undrop_query/test.py::test_undrop_drop_and_undrop_loop test_user_defined_object_persistence/test.py::test_persistence test_user_grants_from_config/test.py::test_allow_read_from_system_tables test_user_grants_from_config/test.py::test_role_grants_from_config test_user_grants_from_config/test.py::test_user_grants_from_config test_user_zero_database_access/test_user_zero_database_access.py::test_user_zero_database_access -vvv" altinityinfra/integration-tests-runner:9d492c2eec24 '. Start tests ============================= test session starts ============================== platform linux -- Python 3.10.12, pytest-7.4.4, pluggy-1.5.0 -- /usr/bin/python3 cachedir: .pytest_cache rootdir: /ClickHouse/tests/integration configfile: pytest.ini plugins: repeat-0.9.3, reportlog-0.4.0, random-0.2, timeout-2.2.0, order-1.0.1, xdist-3.5.0 timeout: 900.0s timeout method: signal timeout func_only: False created: 10/10 workers 10 workers [35 items] scheduling tests via LoadFileScheduling test_system_queries/test.py::test_DROP_DNS_CACHE test_truncate_database/test_replicated.py::test_truncate_database_replicated test_system_logs/test_system_logs.py::test_system_logs_engine_expr test_storage_rabbitmq/test.py::test_rabbitmq_random_detach test_system_merges/test.py::test_merge_simple[] test_temporary_data_in_cache/test.py::test_cache_evicted_by_temporary_data test_user_grants_from_config/test.py::test_allow_read_from_system_tables test_user_defined_object_persistence/test.py::test_persistence test_storage_url_http_headers/test.py::test_storage_url_http_headers test_undrop_query/test.py::test_undrop_drop_and_undrop_loop [gw4] [ 2%] PASSED test_user_grants_from_config/test.py::test_allow_read_from_system_tables test_user_grants_from_config/test.py::test_role_grants_from_config [gw4] [ 5%] PASSED test_user_grants_from_config/test.py::test_role_grants_from_config test_user_grants_from_config/test.py::test_user_grants_from_config [gw4] [ 8%] PASSED test_user_grants_from_config/test.py::test_user_grants_from_config [gw3] [ 11%] PASSED test_system_logs/test_system_logs.py::test_system_logs_engine_expr test_system_logs/test_system_logs.py::test_system_logs_order_by_expr [gw5] [ 14%] PASSED test_storage_url_http_headers/test.py::test_storage_url_http_headers test_storage_url_http_headers/test.py::test_storage_url_redirected_headers [gw2] [ 17%] PASSED test_system_queries/test.py::test_DROP_DNS_CACHE test_system_queries/test.py::test_RELOAD_CONFIG_AND_MACROS [gw5] [ 20%] PASSED test_storage_url_http_headers/test.py::test_storage_url_redirected_headers [gw2] [ 22%] PASSED test_system_queries/test.py::test_RELOAD_CONFIG_AND_MACROS test_system_queries/test.py::test_SYSTEM_RELOAD_DICTIONARY [gw6] [ 25%] PASSED test_temporary_data_in_cache/test.py::test_cache_evicted_by_temporary_data [gw3] [ 28%] PASSED test_system_logs/test_system_logs.py::test_system_logs_order_by_expr test_system_logs/test_system_logs.py::test_system_logs_settings_expr [gw3] [ 31%] PASSED test_system_logs/test_system_logs.py::test_system_logs_settings_expr [gw2] [ 34%] PASSED test_system_queries/test.py::test_SYSTEM_RELOAD_DICTIONARY test_system_queries/test.py::test_system_flush_logs [gw2] [ 37%] PASSED test_system_queries/test.py::test_system_flush_logs test_user_zero_database_access/test_user_zero_database_access.py::test_user_zero_database_access [gw8] [ 40%] PASSED test_user_defined_object_persistence/test.py::test_persistence [gw5] [ 42%] PASSED test_user_zero_database_access/test_user_zero_database_access.py::test_user_zero_database_access [gw1] [ 45%] PASSED test_system_merges/test.py::test_merge_simple[] test_system_merges/test.py::test_merge_simple[replicated] [gw7] [ 48%] PASSED test_truncate_database/test_replicated.py::test_truncate_database_replicated [gw9] [ 51%] PASSED test_undrop_query/test.py::test_undrop_drop_and_undrop_loop [gw1] [ 54%] PASSED test_system_merges/test.py::test_merge_simple[replicated] test_system_merges/test.py::test_mutation_simple[] [gw1] [ 57%] PASSED test_system_merges/test.py::test_mutation_simple[] test_system_merges/test.py::test_mutation_simple[replicated] [gw1] [ 60%] PASSED test_system_merges/test.py::test_mutation_simple[replicated] [gw0] [ 62%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_random_detach test_storage_rabbitmq/test.py::test_rabbitmq_reject_broken_messages [gw0] [ 65%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_reject_broken_messages test_storage_rabbitmq/test.py::test_rabbitmq_restore_failed_connection_without_losses_1 [gw0] [ 68%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_restore_failed_connection_without_losses_1 test_storage_rabbitmq/test.py::test_rabbitmq_restore_failed_connection_without_losses_2 [gw0] [ 71%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_restore_failed_connection_without_losses_2 test_storage_rabbitmq/test.py::test_rabbitmq_select[0] [gw0] [ 74%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_select[0] test_storage_rabbitmq/test.py::test_rabbitmq_select[1] [gw0] [ 77%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_select[1] test_storage_rabbitmq/test.py::test_rabbitmq_select_empty [gw0] [ 80%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_select_empty test_storage_rabbitmq/test.py::test_rabbitmq_sharding_between_queues_publish [gw0] [ 82%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_sharding_between_queues_publish test_storage_rabbitmq/test.py::test_rabbitmq_topic_exchange [gw0] [ 85%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_topic_exchange test_storage_rabbitmq/test.py::test_rabbitmq_tsv_with_delimiter [gw0] [ 88%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_tsv_with_delimiter test_storage_rabbitmq/test.py::test_rabbitmq_vhost [gw0] [ 91%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_vhost test_storage_rabbitmq/test.py::test_rabbitmq_virtual_columns [gw0] [ 94%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_virtual_columns test_storage_rabbitmq/test.py::test_rabbitmq_virtual_columns_with_materialized_view [gw0] [ 97%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_virtual_columns_with_materialized_view test_storage_rabbitmq/test.py::test_row_based_formats [gw0] [100%] PASSED test_storage_rabbitmq/test.py::test_row_based_formats ============================== slowest durations =============================== 282.75s call test_storage_rabbitmq/test.py::test_rabbitmq_random_detach 59.28s call test_storage_rabbitmq/test.py::test_row_based_formats 51.88s call test_storage_rabbitmq/test.py::test_rabbitmq_restore_failed_connection_without_losses_2 36.52s call test_system_merges/test.py::test_mutation_simple[replicated] 36.30s call test_system_merges/test.py::test_mutation_simple[] 32.33s call test_storage_rabbitmq/test.py::test_rabbitmq_sharding_between_queues_publish 30.49s setup test_truncate_database/test_replicated.py::test_truncate_database_replicated 29.15s call test_storage_rabbitmq/test.py::test_rabbitmq_restore_failed_connection_without_losses_1 25.15s setup test_storage_rabbitmq/test.py::test_rabbitmq_random_detach 21.86s call test_undrop_query/test.py::test_undrop_drop_and_undrop_loop 20.24s setup test_system_merges/test.py::test_merge_simple[] 15.41s call test_storage_rabbitmq/test.py::test_rabbitmq_topic_exchange 14.75s setup test_storage_url_http_headers/test.py::test_storage_url_http_headers 14.50s setup test_system_logs/test_system_logs.py::test_system_logs_engine_expr 14.21s setup test_system_queries/test.py::test_DROP_DNS_CACHE 14.20s setup test_user_grants_from_config/test.py::test_allow_read_from_system_tables 13.55s setup test_undrop_query/test.py::test_undrop_drop_and_undrop_loop 13.30s setup test_user_defined_object_persistence/test.py::test_persistence 13.15s setup test_temporary_data_in_cache/test.py::test_cache_evicted_by_temporary_data 10.04s call test_system_merges/test.py::test_merge_simple[replicated] 9.91s call test_storage_rabbitmq/test.py::test_rabbitmq_reject_broken_messages 9.79s teardown test_storage_rabbitmq/test.py::test_row_based_formats 9.54s call test_system_merges/test.py::test_merge_simple[] 7.17s call test_user_defined_object_persistence/test.py::test_persistence 5.64s call test_storage_rabbitmq/test.py::test_rabbitmq_select[0] 5.61s call test_storage_rabbitmq/test.py::test_rabbitmq_select[1] 5.11s teardown test_truncate_database/test_replicated.py::test_truncate_database_replicated 5.06s setup test_user_zero_database_access/test_user_zero_database_access.py::test_user_zero_database_access 4.33s teardown test_system_merges/test.py::test_mutation_simple[replicated] 4.07s teardown test_storage_url_http_headers/test.py::test_storage_url_redirected_headers 3.92s teardown test_system_queries/test.py::test_system_flush_logs 3.75s teardown test_user_grants_from_config/test.py::test_user_grants_from_config 3.64s teardown test_temporary_data_in_cache/test.py::test_cache_evicted_by_temporary_data 3.54s call test_storage_rabbitmq/test.py::test_rabbitmq_virtual_columns 3.54s call test_storage_rabbitmq/test.py::test_rabbitmq_virtual_columns_with_materialized_view 3.47s teardown test_undrop_query/test.py::test_undrop_drop_and_undrop_loop 3.43s teardown test_user_zero_database_access/test_user_zero_database_access.py::test_user_zero_database_access 3.09s call test_system_queries/test.py::test_system_flush_logs 2.40s call test_storage_rabbitmq/test.py::test_rabbitmq_tsv_with_delimiter 2.40s teardown test_system_logs/test_system_logs.py::test_system_logs_settings_expr 1.96s call test_temporary_data_in_cache/test.py::test_cache_evicted_by_temporary_data 1.95s teardown test_user_defined_object_persistence/test.py::test_persistence 1.41s call test_storage_rabbitmq/test.py::test_rabbitmq_vhost 1.33s call test_storage_rabbitmq/test.py::test_rabbitmq_select_empty 0.91s teardown test_storage_rabbitmq/test.py::test_rabbitmq_random_detach 0.82s call test_user_zero_database_access/test_user_zero_database_access.py::test_user_zero_database_access 0.70s call test_system_queries/test.py::test_DROP_DNS_CACHE 0.68s call test_system_queries/test.py::test_SYSTEM_RELOAD_DICTIONARY 0.39s call test_truncate_database/test_replicated.py::test_truncate_database_replicated 0.34s call test_system_logs/test_system_logs.py::test_system_logs_order_by_expr 0.28s call test_system_logs/test_system_logs.py::test_system_logs_engine_expr 0.28s call test_system_logs/test_system_logs.py::test_system_logs_settings_expr 0.22s call test_storage_url_http_headers/test.py::test_storage_url_redirected_headers 0.18s call test_system_queries/test.py::test_RELOAD_CONFIG_AND_MACROS 0.15s teardown test_storage_rabbitmq/test.py::test_rabbitmq_restore_failed_connection_without_losses_1 0.13s teardown test_storage_rabbitmq/test.py::test_rabbitmq_select_empty 0.13s call test_user_grants_from_config/test.py::test_allow_read_from_system_tables 0.13s teardown test_storage_rabbitmq/test.py::test_rabbitmq_select[0] 0.13s call test_user_grants_from_config/test.py::test_user_grants_from_config 0.11s call test_storage_url_http_headers/test.py::test_storage_url_http_headers 0.10s teardown test_storage_rabbitmq/test.py::test_rabbitmq_reject_broken_messages 0.10s teardown test_storage_rabbitmq/test.py::test_rabbitmq_restore_failed_connection_without_losses_2 0.10s teardown test_storage_rabbitmq/test.py::test_rabbitmq_sharding_between_queues_publish 0.10s teardown test_storage_rabbitmq/test.py::test_rabbitmq_select[1] 0.10s teardown test_storage_rabbitmq/test.py::test_rabbitmq_vhost 0.07s call test_user_grants_from_config/test.py::test_role_grants_from_config 0.07s teardown test_storage_rabbitmq/test.py::test_rabbitmq_topic_exchange 0.07s teardown test_storage_rabbitmq/test.py::test_rabbitmq_tsv_with_delimiter 0.07s teardown test_storage_rabbitmq/test.py::test_rabbitmq_virtual_columns_with_materialized_view 0.07s teardown test_storage_rabbitmq/test.py::test_rabbitmq_virtual_columns 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_reject_broken_messages 0.00s setup test_storage_rabbitmq/test.py::test_row_based_formats 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_select[1] 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_tsv_with_delimiter 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_restore_failed_connection_without_losses_1 0.00s setup test_user_grants_from_config/test.py::test_user_grants_from_config 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_topic_exchange 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_select[0] 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_virtual_columns_with_materialized_view 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_vhost 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_virtual_columns 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_select_empty 0.00s setup test_system_merges/test.py::test_mutation_simple[] 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_sharding_between_queues_publish 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_restore_failed_connection_without_losses_2 0.00s setup test_system_queries/test.py::test_RELOAD_CONFIG_AND_MACROS 0.00s setup test_system_queries/test.py::test_system_flush_logs 0.00s teardown test_system_merges/test.py::test_merge_simple[] 0.00s setup test_system_merges/test.py::test_mutation_simple[replicated] 0.00s setup test_storage_url_http_headers/test.py::test_storage_url_redirected_headers 0.00s setup test_system_merges/test.py::test_merge_simple[replicated] 0.00s setup test_user_grants_from_config/test.py::test_role_grants_from_config 0.00s teardown test_system_merges/test.py::test_merge_simple[replicated] 0.00s teardown test_user_grants_from_config/test.py::test_role_grants_from_config 0.00s teardown test_user_grants_from_config/test.py::test_allow_read_from_system_tables 0.00s setup test_system_logs/test_system_logs.py::test_system_logs_settings_expr 0.00s setup test_system_queries/test.py::test_SYSTEM_RELOAD_DICTIONARY 0.00s setup test_system_logs/test_system_logs.py::test_system_logs_order_by_expr 0.00s teardown test_system_merges/test.py::test_mutation_simple[] 0.00s teardown test_system_queries/test.py::test_DROP_DNS_CACHE 0.00s teardown test_system_logs/test_system_logs.py::test_system_logs_engine_expr 0.00s teardown test_storage_url_http_headers/test.py::test_storage_url_http_headers 0.00s teardown test_system_queries/test.py::test_SYSTEM_RELOAD_DICTIONARY 0.00s teardown test_system_queries/test.py::test_RELOAD_CONFIG_AND_MACROS 0.00s teardown test_system_logs/test_system_logs.py::test_system_logs_order_by_expr =========================== short test summary info ============================ PASSED test_user_grants_from_config/test.py::test_allow_read_from_system_tables PASSED test_user_grants_from_config/test.py::test_role_grants_from_config PASSED test_user_grants_from_config/test.py::test_user_grants_from_config PASSED test_system_logs/test_system_logs.py::test_system_logs_engine_expr PASSED test_storage_url_http_headers/test.py::test_storage_url_http_headers PASSED test_system_queries/test.py::test_DROP_DNS_CACHE PASSED test_storage_url_http_headers/test.py::test_storage_url_redirected_headers PASSED test_system_queries/test.py::test_RELOAD_CONFIG_AND_MACROS PASSED test_temporary_data_in_cache/test.py::test_cache_evicted_by_temporary_data PASSED test_system_logs/test_system_logs.py::test_system_logs_order_by_expr PASSED test_system_logs/test_system_logs.py::test_system_logs_settings_expr PASSED test_system_queries/test.py::test_SYSTEM_RELOAD_DICTIONARY PASSED test_system_queries/test.py::test_system_flush_logs PASSED test_user_defined_object_persistence/test.py::test_persistence PASSED test_user_zero_database_access/test_user_zero_database_access.py::test_user_zero_database_access PASSED test_system_merges/test.py::test_merge_simple[] PASSED test_truncate_database/test_replicated.py::test_truncate_database_replicated PASSED test_undrop_query/test.py::test_undrop_drop_and_undrop_loop PASSED test_system_merges/test.py::test_merge_simple[replicated] PASSED test_system_merges/test.py::test_mutation_simple[] PASSED test_system_merges/test.py::test_mutation_simple[replicated] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_random_detach PASSED test_storage_rabbitmq/test.py::test_rabbitmq_reject_broken_messages PASSED test_storage_rabbitmq/test.py::test_rabbitmq_restore_failed_connection_without_losses_1 PASSED test_storage_rabbitmq/test.py::test_rabbitmq_restore_failed_connection_without_losses_2 PASSED test_storage_rabbitmq/test.py::test_rabbitmq_select[0] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_select[1] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_select_empty PASSED test_storage_rabbitmq/test.py::test_rabbitmq_sharding_between_queues_publish PASSED test_storage_rabbitmq/test.py::test_rabbitmq_topic_exchange PASSED test_storage_rabbitmq/test.py::test_rabbitmq_tsv_with_delimiter PASSED test_storage_rabbitmq/test.py::test_rabbitmq_vhost PASSED test_storage_rabbitmq/test.py::test_rabbitmq_virtual_columns PASSED test_storage_rabbitmq/test.py::test_rabbitmq_virtual_columns_with_materialized_view PASSED test_storage_rabbitmq/test.py::test_row_based_formats ======================== 35 passed in 546.74s (0:09:06) ========================